--CREATE DATABASE QuanLyNhaSach
--GO
--USE QuanLyNhaSach
--GO

ALTER TABLE HoaDon ADD MaKH VARCHAR(50);
INSERT INTO NhaCungCap VALUES('F001','FAHASA','Q9','01234','HANHKHATXAHOA@GMAIL.COM','KHONG CO')
INSERT INTO Sach VALUES('S001','CO TICH',10000,20000,'F001','10')
INSERT INTO Sach VALUES('S002','LICH SU',10000,20000,'F001','10')
INSERT INTO NhanVien(MaNV,TenNV,NgaySinh,SoCMND,GioiTinh,SoDienThoai,DiaChi,Email,PassWord,Loai) VALUES('NV01','TOAN','03/15/1994','271324745','NAM','0974881123','GIA KIEM','HANHKHATXAHOA@GMAIL.COM','VERYBOY','L1')
INSERT INTO PhieuNhap(MaPhieuNhap,MaNV,TongTien,Ngay) VALUES('PN01','NV01','10000','04/16/2013')
INSERT INTO ChiTietPhieuNhap VALUES('1','PN01','S001','10')
INSERT INTO ChiTietPhieuNhap VALUES('2','PN01','S002','20')
INSERT INTO ChiTietPhieuNhap VALUES('3','PN01','S002','20')
INSERT INTO ChiTietPhieuNhap VALUES('4','PN01','S001','20')
INSERT INTO ChiTietPhieuNhap VALUES('5','PN01','S002','5')
UPDATE NhanVien SET PassWord = '24689' WHERE MaNV = 'NV01'